SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001319s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 538383 LIMIT 1 [ RunTime:0.000611s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 538383 [ RunTime:0.002674s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (167403,792347,387656,334147,580449,775779,589236,327755,250143,1017122,641448,622176,830243,738123,409893,1004628,624133,377964,19474,939258,645755,922613,867122,102104,17564,280117,901265,388273,753666,965627,612714,373051,1009599,521255,567610,688929,297452,882264,99396,110245,695895,313660,265931,1013808,269014,790271,758594,14166,270592,729093,19741,70917,604006,619046,1030815,653340,314470,619148,701083,838499) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001006s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 538383 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000544s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 538383 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000364s ]