SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 294460 LIMIT 1 [ RunTime:0.000392s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 294460 [ RunTime:0.001662s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (483501,211388,990702,959810,126987,765142,128296,52387,19216,874625,111713,386035,29571,1005535,692069,300054,431697,588895,810452,137881,455175,1042349,403390,276339,684799,233961,537462,483775,876951,397723,600654,73884,862389,597952,830244,274956,319575,269399,806574,874541,551688,108916,556062,745547,739895,466351,849057,541938,570606,551584,583679,269673,826721,630731,141620,852981,24039,632380,673659,1025646) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001053s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 294460 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 294460 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000487s ]