SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014110 LIMIT 1 [ RunTime:0.000288s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014110 [ RunTime:0.001683s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (803519,51097,445867,664951,763734,560245,371694,102442,225053,817704,1012004,59475,268285,488083,210312,299097,906306,28381,631680,773880,508154,243780,808892,857573,783436,236351,155577,932284,63561,713111,124052,839160,748564,687163,237504,500156,871521,486637,109113,1017212,352317,454080,208935,225721,438352,75921,481496,888873,143364,311655,67716,1040033,865481,744833,954494,804564,378027,246930,267448,584561) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000984s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014110 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014110 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000541s ]