SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001241s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 513648 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 513648 [ RunTime:0.002029s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (265032,429500,167115,1009684,751250,180933,190534,240046,435411,672850,471506,368383,185069,832690,736901,778782,679337,446974,941939,230638,629001,942906,495709,361856,141188,1022683,925484,165791,410713,1019130,485822,241289,750429,965149,366488,221476,960919,585712,169719,566906,464821,753997,26747,93240,333500,821669,145651,904880,463800,66142,69580,500981,625622,253753,63645,1003188,336385,802585,655767,323608) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 513648 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 513648 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000515s ]