SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001747s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1027887 LIMIT 1 [ RunTime:0.000442s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1027887 [ RunTime:0.001855s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (198722,605839,598075,542276,215572,761002,606850,414251,884901,680979,108197,528083,355463,800196,1000902,507317,130596,325516,676387,446054,798628,66041,803415,801172,125052,240384,218099,289818,735186,608456,758340,225593,440611,321898,985005,983333,142441,93637,116787,771944,747167,348046,975617,279435,879380,652305,171341,1012123,795730,216636,559996,249655,534916,624589,680908,990014,1031560,721338,640882,606692) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001051s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1027887 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1027887 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000638s ]