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` = 568518 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 568518 [ RunTime:0.002481s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (151536,143632,304669,103994,69574,449600,294487,411005,771182,193610,560133,756792,304337,537502,8748,537835,560566,242366,311571,577076,308527,843648,756194,219057,1028148,666321,87346,582554,686054,157840,450298,26787,660023,346860,976358,354888,917295,685465,880225,981875,508022,733338,531606,454935,30037,722790,640840,700628,309209,1048338,947153,981197,593570,996196,534315,913671,1012106,241475,107084,383875) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000978s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 568518 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000322s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 568518 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000481s ]