SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001253s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 524673 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 524673 [ RunTime:0.001514s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (545838,811494,545700,767784,739970,386094,1006924,339108,97818,430759,409292,997585,648923,492556,1009414,377535,206383,607316,459903,679024,572701,47108,165313,122504,778859,607450,948613,297131,357937,213782,668728,219819,318154,910445,740538,972181,86917,680445,906209,845729,361878,684799,862528,401359,185095,170680,196956,451887,201516,862760,717740,724862,211251,362003,37723,532840,829308,268367,170854,175186) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 524673 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 524673 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001828s ]