SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001111s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 319149 LIMIT 1 [ RunTime:0.001452s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 319149 [ RunTime:0.005084s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (569623,939259,1010861,518752,848949,373105,856500,774607,910088,525924,587408,714347,314234,624139,102987,134994,232701,691633,420105,69976,68266,660570,385984,744093,698725,426033,430233,511775,428064,361460,689223,323645,1001391,633201,847289,1005439,1037752,789457,645771,376389,58453,10956,291693,255553,581338,646831,760532,163499,732948,34564,391324,629341,694343,862668,576309,813375,1014056,904512,493446,440186) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 319149 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 319149 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000522s ]