SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001445s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508271 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508271 [ RunTime:0.001683s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1040867,647255,737340,63984,692721,68082,807527,768196,375701,971657,1043958,1009461,325670,475605,820759,343086,158620,130288,265901,557835,221170,875224,792998,315874,710675,1045447,598631,636261,94208,841038,205374,410192,1035583,503038,475208,691318,998097,885357,542624,391466,36784,448840,204416,793897,438654,472750,927902,923402,743059,608169,638713,216488,923706,294076,226678,27836,672493,669082,659352,147204) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001116s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508271 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000484s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508271 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000599s ]