SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1043582 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1043582 [ RunTime:0.001808s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (78746,400175,114841,959309,994871,315905,164262,159515,966049,908772,929280,282403,424032,53199,454833,587595,155882,493143,363694,65433,534243,662383,675756,846685,556546,387562,331952,210027,402858,95936,532879,934330,567205,338685,851632,853963,484059,909044,645141,653090,489932,235575,428752,754286,276905,845017,531549,964985,612785,635243,782992,992545,230639,495053,343909,675062,234662,650143,117258,140632) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001298s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1043582 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000477s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1043582 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000481s ]