SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001802s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 598584 LIMIT 1 [ RunTime:0.000532s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 598584 [ RunTime:0.003852s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (305351,808608,916934,976610,207865,913135,809518,112047,1029914,11888,828689,599534,276015,497123,477329,522773,22461,948215,524394,98426,900056,388635,180747,566175,708480,790881,784651,505496,734793,884335,1002135,940604,874917,724574,817070,774147,124026,207298,676814,764657,752648,64633,895481,188438,1044814,653227,1009018,98961,470152,728300,908042,590572,289588,312415,504101,578795,834171,429837,538015,710547) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003191s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 598584 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000584s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 598584 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000663s ]