SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001444s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 445181 LIMIT 1 [ RunTime:0.000582s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 445181 [ RunTime:0.001917s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (600705,164511,726206,682840,848233,784478,411041,916984,1046789,322320,778965,297159,441490,542201,13260,110736,917047,321679,993997,197396,166691,729592,620128,87575,99580,665412,459260,78580,1046016,574270,603636,153349,271879,314608,313957,815565,462342,28171,856581,279705,338356,794447,757863,930282,407757,237674,350522,275817,856219,703918,985991,1022802,201901,909867,707053,607108,893409,53310,172786,39995) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001270s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 445181 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000522s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 445181 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000932s ]