SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 445876 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 445876 [ RunTime:0.001727s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (34965,531755,939798,838031,1014444,785722,246031,39813,953660,596682,568568,444489,515931,249178,357225,1048679,46542,177574,873844,643504,551717,132054,346138,399663,758299,242542,578626,380707,443806,431880,146116,41824,307709,156121,753548,219803,492963,459699,477047,721452,834130,463579,447872,844444,519784,218455,240587,145688,885809,1044447,375478,571838,789995,73347,532316,504442,1028394,323941,256342,500104) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001938s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 445876 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000512s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 445876 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000627s ]