SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 68203 LIMIT 1 [ RunTime:0.000290s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 68203 [ RunTime:0.001659s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (355959,871031,111795,951302,759316,146221,901902,491596,525671,306997,24678,137079,916826,761928,444053,437412,43164,549129,818296,127940,565254,533361,261021,484775,135373,22632,2106,849549,962423,958897,67682,273727,266078,326537,244216,146212,360432,588595,243191,932374,827866,230533,991827,262289,112287,480933,746660,860496,502646,954629,164783,663193,489398,338733,764259,886579,576556,326871,195854,954106) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000998s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 68203 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000443s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 68203 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000565s ]