SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 44711 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 44711 [ RunTime:0.002085s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (991390,480445,505322,378108,854244,130588,1041927,692187,223410,596702,763037,877054,877143,917940,674578,776455,556545,823184,695793,83624,282349,10274,84808,806978,782953,1044695,827821,35375,1039802,837356,955667,141023,931087,233173,1002713,770359,418317,395475,458824,384214,265380,707910,607838,72188,427142,92270,34399,697614,238302,12308,197379,295965,914363,303583,298819,53286,680204,178348,489956,60971) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001233s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 44711 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000509s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 44711 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000626s ]