SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001084s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 518417 LIMIT 1 [ RunTime:0.000675s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 518417 [ RunTime:0.001578s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (127549,425806,42001,1017781,378839,483405,498364,285533,332231,663171,371340,309466,408532,209491,156808,538437,1031471,903203,1008316,663933,165347,989259,238519,659084,841494,1032305,547901,121995,349530,385436,921733,995303,168835,561130,51532,543847,602352,836868,252983,164503,428797,1024446,404354,767017,804580,820222,1036865,809679,656586,826633,567559,901143,214652,58361,240961,302289,881824,15887,741332,568671) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001045s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 518417 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000430s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 518417 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000583s ]