SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 818114 LIMIT 1 [ RunTime:0.000293s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 818114 [ RunTime:0.001512s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (672023,15788,258496,154621,1037081,494275,40244,852704,232002,174063,940946,453097,680930,571994,631911,607514,1042000,394091,208684,28081,170549,921969,44743,44420,742386,617436,272706,886930,943705,939828,160901,388283,633930,373299,25708,862891,870281,801766,1023013,5501,52131,484129,799795,982158,308856,688822,351912,643672,21290,602044,781971,540205,448384,762666,600454,207466,170056,781073,174257,582978) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001037s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 818114 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 818114 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000689s ]