SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 556458 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 556458 [ RunTime:0.001901s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (424927,398160,739918,729136,66395,493136,244900,204779,441511,866425,816641,424791,141659,585473,551230,309919,358624,669249,1037576,45104,786570,367552,752534,756730,494880,630920,221226,640256,198558,890665,1020076,829926,301176,925174,886760,322151,810056,344383,538552,778843,753737,216732,696372,760830,513208,806478,93980,883855,621625,763889,597443,68320,808171,512783,202492,515704,889240,189372,420675,749028) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000974s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 556458 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 556458 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000465s ]