SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402451 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402451 [ RunTime:0.001849s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (655234,451856,737728,87852,516589,928819,1042474,337872,647299,263292,637799,115853,900163,800467,850718,849823,503296,308064,797845,211696,167536,172613,347893,532738,282689,502526,668,208609,584326,283122,746718,262483,955640,223841,322288,879176,763425,338070,940403,371446,495581,529972,851041,26286,639525,1003885,185942,551100,688165,443804,524794,248172,1036000,617871,682177,307392,887273,974637,585380,941596) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402451 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402451 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000503s ]