SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001750s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415158 LIMIT 1 [ RunTime:0.001474s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415158 [ RunTime:0.002002s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (309068,948257,1016358,286219,659266,984048,461263,863137,963037,715481,337308,952201,711333,926149,421215,202306,952224,193705,890509,156209,839768,464137,645141,900528,786525,692182,916085,976386,369949,392487,204645,450806,484102,895810,621432,987793,600770,843755,959694,533651,452338,422288,495629,512152,399331,211669,242020,382894,121777,340348,744774,137492,794485,733028,205453,632275,759938,783182,814311,915499) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001558s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415158 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.005196s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415158 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000820s ]