SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001261s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509566 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509566 [ RunTime:0.001661s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1040673,31250,67933,482210,764172,56676,573110,901418,63921,100420,956433,460944,891612,321126,555266,653521,497594,614468,880693,43880,893187,408408,70908,506707,773370,616579,105569,512493,571090,214875,85648,415236,967789,464306,206209,131471,210109,487828,739124,121770,430335,2052,317084,43283,980826,893526,692055,434069,912883,1851,470959,784150,260951,466596,604228,742839,862427,785939,858393,246333) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001947s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509566 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000463s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509566 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001656s ]