SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001220s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415068 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415068 [ RunTime:0.001544s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (319991,571415,978183,1019192,226107,439992,1031061,933529,9805,366450,605813,439603,654101,571356,37786,381628,677362,936951,853533,491494,809772,97467,783079,20950,641749,1012133,671672,686717,464147,266106,37152,805666,342534,122826,960241,320711,761514,516655,633556,841327,411526,383156,659506,274322,303837,933601,588717,180655,685338,1008393,84269,938534,577746,219009,741183,595950,199117,178750,773878,858846) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000973s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415068 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415068 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000553s ]