SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001124s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 536197 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 536197 [ RunTime:0.001589s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (988955,431583,310003,936710,286645,641632,402122,381923,324985,930308,430381,932587,972366,411736,312366,658985,126972,1006354,133630,871382,1024006,288759,312187,662647,172152,1026110,374640,891577,633057,144885,419552,325698,515317,1020756,934871,595674,835443,227068,331418,36973,936042,138360,85411,904096,62520,900006,638226,554867,937014,194112,166956,579743,552442,878119,911820,1776,821978,279621,716544,181113) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001007s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 536197 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000326s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 536197 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000529s ]