SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001274s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 105658 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 105658 [ RunTime:0.001877s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (615278,483860,975695,647562,3985,129552,638640,339124,521916,93088,317279,789958,893678,76755,766521,875636,743321,418882,643409,783852,49293,622768,75306,641874,843860,620802,302924,929691,971526,593154,485596,995415,824500,343976,733085,119121,741472,665146,852716,452366,153498,803938,419098,691772,667262,105687,218194,395721,525428,993935,462649,299092,994796,42258,941280,960949,813240,159981,446716,821584) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001029s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 105658 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000332s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 105658 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000607s ]