SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001789s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 438715 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 438715 [ RunTime:0.002006s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (714488,707404,193710,380593,117182,925130,969976,1010001,888251,232370,307465,603376,430680,614758,530824,575707,673644,710198,49200,211638,830172,913338,748563,284157,780616,285868,63636,985136,827213,1043671,767566,850600,121284,417322,279376,837041,170877,183011,1038697,199385,387861,644455,425708,916286,175500,540465,775768,451653,621572,564505,32276,785288,673962,851304,896300,567310,926248,472219,716764,185676) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001096s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 438715 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 438715 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000539s ]