SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001362s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 417294 LIMIT 1 [ RunTime:0.000405s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 417294 [ RunTime:0.004300s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (89831,120908,886001,307133,596696,714320,97901,943013,404370,592369,528572,280243,913213,1006628,344263,340113,298089,213742,863462,964051,501932,953146,422944,360894,481429,1041949,251868,8458,70352,645367,757499,668685,4134,793149,265588,575529,958414,884266,93899,262172,501123,742215,497363,290992,224804,308144,174624,596114,427427,426880,578086,537801,589302,146985,337491,718414,904688,673230,98690,206529) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004428s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 417294 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000416s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 417294 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000643s ]