SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001510s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1001028 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1001028 [ RunTime:0.001587s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (964301,50110,468093,801927,680372,828268,64337,780653,421522,636651,60578,53772,140439,73030,161156,798865,83328,980837,448711,1010019,39073,1002845,818930,128255,937279,877044,282391,727998,47221,570373,420961,19349,887088,601236,210940,874264,888689,667362,57587,695952,821500,214194,999453,322723,929599,586374,614638,877257,789323,949206,224029,282793,464976,334064,795782,951717,523020,45499,455891,117376) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1001028 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000416s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1001028 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000574s ]