SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001116s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 301412 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 301412 [ RunTime:0.001484s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (566569,1019308,257566,629140,493962,290443,475931,357417,53448,268770,122370,292005,417932,695286,174686,347182,929294,356178,101829,293496,61472,804650,442127,956344,944795,335766,769558,39935,423774,539335,286397,675743,896515,417802,725511,683080,779392,225463,700636,556606,413032,286655,704299,379347,911145,220408,468439,448047,371486,582187,328445,360423,282311,931316,783131,768861,335720,878241,232086,676825) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001008s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 301412 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 301412 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000387s ]