SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415291 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415291 [ RunTime:0.001792s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (313883,1010482,200949,610395,655630,189222,864672,72550,765101,224853,309596,752543,221653,404833,67172,642696,641371,9280,612860,734365,869471,1033367,713561,857331,953144,214164,717165,947962,788629,331,385453,292744,228986,693673,232084,922082,550700,901559,761359,441692,385824,894685,965478,673052,902080,255765,762133,432569,776445,747717,224505,994872,1048707,29570,877497,110979,333401,581186,273718,971786) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001648s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415291 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000581s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415291 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000609s ]