SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001278s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 316907 LIMIT 1 [ RunTime:0.001143s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 316907 [ RunTime:0.002339s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (801069,764059,815473,575384,605263,779812,336287,573963,817602,197087,304834,19272,961856,498590,138591,64449,278153,550790,606851,653269,238351,506377,206795,685601,375483,91149,636661,972738,348934,690360,47158,386993,931153,290339,230145,579455,874274,253539,549077,951361,629250,432915,970330,38847,436676,1001982,903233,226308,988123,142200,712327,135927,728517,840612,773517,576398,95263,845451,637422,471038) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004488s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 316907 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000423s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 316907 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001000s ]