SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1021169 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1021169 [ RunTime:0.001830s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (701188,608781,140221,640372,135003,40240,385559,653449,519447,440986,167580,362257,554185,952139,532787,687055,710326,87584,515501,374252,572918,427714,839850,150631,917137,989298,1041623,128194,53252,684040,998836,334362,563267,4719,663522,215681,465292,709371,393720,134949,893402,380081,545323,899286,624520,645970,544685,388206,387086,329938,485192,92331,242635,659088,282049,332501,273091,53313,882867,938545) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001081s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1021169 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1021169 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001337s ]