SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001306s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 483043 LIMIT 1 [ RunTime:0.000389s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 483043 [ RunTime:0.003390s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (368938,517949,706595,852730,650972,994463,959815,315744,60442,265236,126842,352993,718611,651178,320273,905185,746438,100504,503970,573476,869947,332264,286057,648673,817226,458135,148861,692966,180408,13522,452355,346083,251223,539901,845697,531482,800174,72918,383384,62996,30591,554193,23196,658736,34181,842090,192524,1006269,425804,833730,877259,719263,706878,538393,457934,433372,976203,424688,752658,474198) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001270s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 483043 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 483043 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000669s ]