SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001308s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101236 LIMIT 1 [ RunTime:0.000494s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101236 [ RunTime:0.002792s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (266107,558600,970666,813148,881455,228775,445972,633380,826216,753343,890448,260450,271186,775172,198756,341364,641906,619190,180737,858535,90418,549882,107686,855465,742768,477045,570263,548602,243853,166822,572163,518696,162399,346654,347019,852997,84328,12206,68344,41510,41814,878459,112808,283250,38456,535421,1044513,862555,1023890,264961,854861,75266,339969,221857,1041628,499045,844195,830796,69735,424818) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001040s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101236 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101236 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000549s ]