SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 105405 LIMIT 1 [ RunTime:0.000296s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 105405 [ RunTime:0.001634s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (154773,307344,622652,743112,152832,653709,307753,349086,492558,676196,359299,667097,908810,746933,106765,886401,579289,667794,556880,939871,754941,900328,362188,975197,577999,762190,927389,314536,896836,270477,291444,179546,321981,682496,66234,533518,95736,1040864,415520,417574,129893,300015,172111,245908,539381,483824,894500,1024215,487352,391520,624901,805288,862349,523263,781606,663964,584669,778460,669697,134086) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001032s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 105405 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 105405 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000848s ]