SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001266s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 472040 LIMIT 1 [ RunTime:0.000424s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 472040 [ RunTime:0.001903s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (114919,103576,513743,470254,669114,773664,438788,869317,896960,452995,227399,702160,326739,422654,322340,998265,438181,143417,76074,200657,1016553,446029,106013,802148,222055,293852,329528,993007,662238,939446,678324,1037224,554088,1024747,355863,987006,496234,1022644,589656,857950,951588,62609,51431,483972,275356,394042,64030,790987,694522,489473,475573,258230,961851,893800,68913,430550,1028325,820626,599965,808291) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001277s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 472040 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000704s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 472040 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000680s ]