SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 530026 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 530026 [ RunTime:0.002069s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (637189,250806,285843,906827,649140,239649,701698,343656,682044,79583,24729,386660,1021949,766608,776535,315522,836910,793246,346008,711080,125705,877908,385045,765601,115137,217820,643993,1029175,274396,222080,242749,80087,836226,669835,18493,71525,271219,14068,719054,318017,986949,765390,29840,553170,968922,336973,347242,597558,270674,157311,484402,578351,483811,285429,695161,832716,875246,839450,182510,678386) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002808s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 530026 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 530026 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000416s ]