SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 103021 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 103021 [ RunTime:0.002624s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (993007,413401,154839,1022500,22513,191917,976015,31790,288640,188200,108963,320492,581608,171332,836963,480576,333648,33944,526349,283023,325328,559869,77727,459099,75544,202500,597562,185295,494903,835122,325221,982743,751999,3139,273557,20490,454349,29705,446400,1016053,33959,917530,109928,22582,467163,521516,508368,777763,523398,43316,977987,143879,152452,1021571,171275,73341,871210,757818,768017,688630) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 103021 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 103021 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000605s ]