SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001119s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 336907 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 336907 [ RunTime:0.001554s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (434182,655560,97381,121213,551474,355579,376012,389659,719204,969422,145801,427440,394452,325769,525581,684791,54391,45050,539053,865800,216242,915926,893044,650438,886140,109696,998295,998056,785185,222255,491491,878040,44103,1043022,228390,1030758,1022060,597656,617719,844269,446123,837071,537213,671357,689781,264426,302090,69530,60772,182525,242366,664772,354447,744358,85026,743386,990491,955416,322614,625560) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002462s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 336907 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000806s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 336907 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000557s ]