SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001219s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 283455 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 283455 [ RunTime:0.001556s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (253514,811093,1013992,444937,381813,243080,500390,57062,340705,361855,363860,637128,142342,465189,481202,607141,529393,847776,1019386,846844,841453,852204,324653,731545,1035758,594646,700646,246921,944901,791437,537532,28477,321080,1027555,1042278,492630,193640,505632,759933,68641,400083,391114,943245,488383,909651,634415,23341,372431,362126,665002,416566,938031,379643,154496,373004,57987,857133,34484,143222,1047600) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 283455 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 283455 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000566s ]