SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 286718 LIMIT 1 [ RunTime:0.000308s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 286718 [ RunTime:0.001530s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (406519,404193,451195,324149,862822,753764,420587,382083,417907,338146,943537,457845,364042,107105,189532,1046706,780379,630544,226337,269997,493773,470544,722725,889187,536559,24358,271278,519495,669942,461176,938803,34880,641304,1043000,536725,1009862,536066,293795,612203,611271,106618,655901,806278,23115,929523,856904,297199,145006,1028949,683688,261125,1036312,106649,823140,184542,388834,939760,152911,440610,507034) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001104s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 286718 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000332s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 286718 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000397s ]