SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 310558 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 310558 [ RunTime:0.001472s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (559196,415397,405942,499573,947913,1025523,42094,683846,90219,777592,141103,1045187,1036575,171241,792745,251396,1032175,608129,352531,926728,827888,739104,334260,250610,339985,11523,553954,651395,746500,39112,412308,415213,414987,275220,878820,759800,202331,774286,364868,502658,44732,219731,273130,126081,162561,349951,34389,448753,1037386,784035,607187,1002230,538620,365801,122405,624064,396892,1002991,650012,29079) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001004s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 310558 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 310558 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000532s ]