SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 281029 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 281029 [ RunTime:0.001971s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (142985,867546,948699,538258,532921,774122,935906,429824,689639,1037508,193670,108711,654027,144523,969068,150395,318649,705535,230612,864434,247114,937838,930916,858968,640062,501910,93748,941622,355737,587901,201267,747975,816928,445238,168949,851755,832242,827504,409260,348056,957821,694594,828179,654588,923631,1042282,565741,466243,747145,1028642,281012,167577,175946,638067,300763,725798,303101,376806,98598,180969) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 281029 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001330s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 281029 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000414s ]