SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 347118 LIMIT 1 [ RunTime:0.001292s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 347118 [ RunTime:0.001820s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (422032,108460,444986,109108,200001,455300,201774,973921,951533,720423,332885,131402,566138,137360,426373,382772,391277,751686,944792,584108,235267,635404,966943,398883,1039487,454464,355745,31770,41534,710588,278182,944495,290793,747132,798027,71512,715662,51545,17675,833455,452028,857012,404813,727984,172207,494952,413908,866508,179688,608694,619060,600616,277587,265794,871763,437664,269292,168045,738315,336630) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002710s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 347118 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000523s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 347118 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000607s ]