SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001328s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1036832 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1036832 [ RunTime:0.002161s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (591604,587710,864344,246794,67919,914038,60934,172874,291021,234243,255979,945386,982613,315018,201700,787219,758819,612683,432701,710140,923360,691620,879538,560011,670436,268461,853919,442901,1037986,310425,673465,496257,747130,910597,234373,168376,154529,513075,312812,662977,414183,232607,63545,24978,400169,38568,212719,435205,585436,428221,159265,315735,682895,80536,313414,952442,666181,555245,612562,482357) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001062s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1036832 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1036832 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000512s ]