SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001390s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 284923 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 284923 [ RunTime:0.001616s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (919410,509576,714798,467126,150682,97924,951283,670202,380272,88700,202844,896125,168717,513376,452239,25152,380522,313353,635824,584838,517524,23372,471068,497355,1001879,262001,66995,898278,463992,282753,161926,198406,34227,266280,890582,984576,82889,490310,827939,553757,640608,521221,815746,954938,612795,198228,24593,667606,768519,600819,318719,733764,512585,322553,148601,428696,889804,885941,422516,93251) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002006s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 284923 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000438s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 284923 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000511s ]