SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 44450 LIMIT 1 [ RunTime:0.000473s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 44450 [ RunTime:0.001830s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (280714,955398,114431,1020033,830402,572222,698369,360068,367561,463924,816624,399198,371231,332683,388210,423491,197706,209023,1035975,133492,765753,571074,267916,772798,228364,985445,969075,713320,383699,610590,195029,999239,48197,995919,879754,135151,951904,678690,245096,274034,317013,483788,753641,215915,449234,566947,413323,640250,555317,272059,678885,647654,1027309,469108,519156,77720,210174,709942,97111,585853) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001627s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 44450 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000486s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 44450 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000611s ]