SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001649s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 437313 LIMIT 1 [ RunTime:0.000928s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 437313 [ RunTime:0.003100s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (3059,638283,476777,331016,6521,820203,1012883,443139,522196,170262,846368,225912,876604,143205,716181,26542,456772,878478,591228,554448,195524,678852,454923,26218,931681,1041347,970250,514538,58948,1023700,13080,372931,1007940,144322,205533,965229,589224,1012233,216363,819557,348099,309802,967395,144768,464393,363822,118639,441511,745229,193964,753298,597172,649235,641483,787394,727616,986522,1039755,493168,27509) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002269s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 437313 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 437313 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000557s ]