SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001243s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 281063 LIMIT 1 [ RunTime:0.000416s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 281063 [ RunTime:0.001658s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (773250,511652,583792,907635,767365,383834,119941,750270,78512,520702,311587,274069,284491,378251,717961,943201,262108,367359,573884,406281,7121,31790,32315,105841,875134,251615,1021113,111767,396249,181707,768641,714642,963639,613648,635073,53497,1030966,785549,833639,545473,517158,737142,770575,387424,157158,98928,658698,460743,77889,413690,738217,155162,587541,42527,180533,309787,670044,612695,273797,884530) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001113s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 281063 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 281063 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000510s ]