SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501304 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501304 [ RunTime:0.001649s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (826075,245192,498707,466841,471423,731370,72341,959633,293856,575250,827380,84722,321144,944950,1012218,327222,503882,64427,711826,1008606,648642,490351,811760,228308,284007,231252,326634,191453,790622,692114,515409,1001861,668100,906627,364419,628185,521303,464714,1024802,123690,51495,606665,577543,218054,427044,864008,387743,153010,111484,248379,912057,144433,149575,761769,273452,1032284,933689,477714,12080,972899) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001102s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501304 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501304 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000546s ]