SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 543241 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 543241 [ RunTime:0.001469s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1031746,669905,148181,93763,252602,378634,496306,540973,375159,918720,278245,434809,1034103,498041,870528,319086,210103,878051,675424,707415,608293,1023666,219215,411041,316219,312092,142871,697000,514387,1027989,303216,1001108,922159,398510,688886,382589,932222,163961,570749,523722,215579,505813,1002862,137660,823324,757826,78480,37050,860528,485360,181114,392009,335643,504548,285748,443944,484666,493444,1029578,720766) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001034s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 543241 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 543241 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000464s ]