SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 714913 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 714913 [ RunTime:0.003929s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (668314,491992,264350,401292,802779,638206,471821,789822,49174,318444,674216,775656,89917,508393,434471,583396,162130,545470,1018445,1007876,1047154,487134,790077,58023,286161,24232,520747,738590,191185,124372,478078,413210,256043,29657,28750,1003543,202072,712080,655889,832641,38026,739102,25079,1039745,233974,69422,451797,504280,292361,567646,1004779,816127,421400,758706,135638,761541,813025,530087,18110,151135) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001107s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 714913 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000436s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 714913 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000543s ]