SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001361s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 516415 LIMIT 1 [ RunTime:0.000462s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 516415 [ RunTime:0.002980s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (104792,777731,866648,435149,971377,187651,719391,345422,867715,871894,655014,672369,600076,775839,164344,27628,934172,999873,699112,359399,601826,376419,189918,150013,434213,419034,144432,411856,1038255,898842,135184,260999,114784,848085,519396,393951,313119,220743,757369,254317,858617,938406,76984,494213,286346,759651,507963,226656,47106,346745,109992,944828,507752,887914,612532,971518,6933,194738,70790,505231) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001796s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 516415 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000466s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 516415 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000587s ]