SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 104147 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104147 [ RunTime:0.001679s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (850994,905397,402379,163256,849473,132595,130310,222662,928482,452212,798696,248199,481159,906481,393457,182631,179455,665742,634296,99536,45480,230640,1016794,1004673,250951,462401,634768,992623,655145,383331,386461,195910,232520,375695,1041236,351299,417411,625468,467978,164111,756842,107836,442685,552350,337598,313910,647879,471032,267615,417578,658221,946639,248274,602838,262338,452617,262074,236211,615298,764613) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001511s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104147 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104147 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000633s ]