SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012339 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012339 [ RunTime:0.001458s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (864528,1024072,134501,129918,547629,737596,963977,209057,547503,619530,253450,632397,340903,669261,405996,104433,375363,949764,891505,312614,759225,251568,131721,924724,729507,739489,612467,360705,391945,47654,475460,193730,523324,674101,308564,197418,196539,703446,781517,121362,770728,919796,335553,777391,694572,989281,534124,185851,1041569,705804,1007468,1005657,731833,289452,585698,514295,485257,159191,213899,695451) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001047s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012339 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012339 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000544s ]