SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001280s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 771093 LIMIT 1 [ RunTime:0.000398s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 771093 [ RunTime:0.002081s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (957587,28867,1031069,842242,792280,963851,725653,108300,793635,208457,177277,938078,316818,460372,604326,49127,976691,177999,471534,963592,130834,186810,288435,966717,790621,202553,1027589,332534,616777,850287,109715,180512,790783,403535,693398,872325,934178,880512,913640,377237,24215,349803,868812,485799,909064,752409,273132,282691,130522,462197,163773,1005678,372792,415761,1015299,722280,826992,157470,391537,1019080) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001293s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 771093 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 771093 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000547s ]