SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 961010 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 961010 [ RunTime:0.001195s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (844134,234616,405408,172072,608540,579543,587654,118981,44019,391643,797133,963615,236803,414680,891421,241183,961876,632252,693141,706624,247071,934308,670146,783565,560513,112450,734363,805788,395202,614942,689431,538824,211357,383042,543864,543950,345440,438561,605056,970595,785857,377233,701762,781602,714433,45392,187749,780497,943945,917152,19697,182545,377182,599024,203109,39864,267323,273970,474361,945889) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001073s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 961010 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000334s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 961010 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000624s ]