SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501592 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501592 [ RunTime:0.001614s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (280868,688775,592217,307231,666992,787185,817449,160099,444157,124703,574001,862667,184363,219269,571136,676593,443594,865612,367129,944202,900600,462392,198042,69680,26908,1013553,88406,52540,972215,268341,207914,835532,646142,1042607,251702,940909,615037,834046,115958,14555,485110,396329,113506,483595,427755,864657,201843,451107,66674,281350,574079,233083,907091,210371,63913,464464,21931,130577,134321,44097) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001327s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501592 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501592 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000429s ]