SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001326s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 497311 LIMIT 1 [ RunTime:0.000393s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 497311 [ RunTime:0.001732s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (852418,984171,595233,277209,811543,1024887,155103,185005,353128,53169,619100,44183,777617,10833,702313,642040,808826,950794,959404,474705,860519,502383,206416,597116,989337,544469,794157,120213,928057,51207,619687,246949,91557,793101,328824,668574,390131,617521,960188,480887,872595,668118,681949,4011,401695,1046310,267931,1002198,840437,649920,257230,57209,182426,1022171,261419,443484,451752,344769,1041148,615597) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000976s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 497311 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 497311 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001206s ]