SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001368s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1030072 LIMIT 1 [ RunTime:0.000430s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1030072 [ RunTime:0.002075s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (77599,191150,866964,745029,160845,510445,1044179,102470,71642,872625,781435,3198,862698,860443,1035176,1027635,1007646,76434,133165,916954,814356,317966,1009695,22973,924721,598200,465428,505905,359944,142107,773746,200366,980701,788886,957101,171446,1005078,855242,10542,175857,139739,14891,752702,170378,919318,313746,57289,685004,108316,949053,311660,367498,373702,796544,29129,140321,255261,696172,222353,209356) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1030072 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000448s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1030072 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000412s ]