SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003418s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403115 LIMIT 1 [ RunTime:0.000415s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403115 [ RunTime:0.002442s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (831063,149945,294601,370385,476740,13795,31015,783952,54662,495591,1028553,581860,4390,539961,384168,337181,250395,664995,464267,487508,826801,481597,727210,245542,479153,594580,402652,407274,425169,811181,743065,688639,279437,442211,312681,533291,907219,489247,251977,276101,704296,842342,642262,325217,158518,548153,545304,571253,70520,484941,245970,576630,964771,320391,194990,459202,1019399,694588,911722,183744) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001516s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403115 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000628s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403115 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000741s ]