SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001400s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 861117 LIMIT 1 [ RunTime:0.000415s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 861117 [ RunTime:0.001897s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1020097,139978,802408,859954,352660,643205,19885,588453,403007,499185,407336,798323,908214,426497,1011073,347207,560982,309103,416562,660496,500940,995211,1001038,976017,149570,501711,983454,983808,170935,389157,105496,539045,434647,477560,545518,497490,292716,422880,103972,97109,268708,600832,140166,48769,906633,508644,893981,793525,1010087,337097,843453,610764,357611,295479,610464,199441,720437,686636,655694,650914) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 861117 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001850s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 861117 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000649s ]