SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001534s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201029 LIMIT 1 [ RunTime:0.000712s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201029 [ RunTime:0.004239s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (130591,923899,538755,400869,595769,479725,387128,831185,655958,622010,627118,250877,651555,41375,466526,801807,884370,70083,382258,177150,311665,1013298,753393,709729,434717,850843,438984,435047,597636,418037,941809,670475,564432,1039803,265340,200062,598735,866111,503802,1041494,510655,311617,104784,1046934,660545,507191,745712,552182,608237,516832,535802,485261,241872,181363,951497,278116,746976,331931,926828,959895) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000995s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201029 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201029 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000572s ]