SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001379s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 111063 LIMIT 1 [ RunTime:0.000398s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 111063 [ RunTime:0.001443s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (459213,811502,573852,152886,110968,263424,65531,470125,397372,661032,561498,119195,109759,226506,145079,707936,349751,686679,879741,827515,1017518,220278,646181,432742,600887,47267,1037497,126988,361603,476918,48295,638646,180489,242819,330924,569106,604793,967523,935136,383129,32286,813683,774461,752579,766430,418371,68417,674799,57827,239354,456722,430024,173872,602263,603158,466162,707450,925931,71445,498066) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 111063 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000419s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 111063 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000504s ]