SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001297s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50681 LIMIT 1 [ RunTime:0.000482s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50681 [ RunTime:0.004809s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (652810,660726,501216,893676,202750,154586,932026,113045,505073,623430,172110,244035,934199,819722,533206,653752,123234,302343,692036,353160,579899,465451,289935,500760,361452,173063,49907,290051,982206,376871,454993,1012825,766,362495,209529,741932,433448,981448,534674,638349,258016,64068,304338,134261,431639,676778,854967,357350,601344,164947,845370,305436,133207,208303,930358,95112,897734,280955,317873,132416) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50681 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50681 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001544s ]