SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001291s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1022035 LIMIT 1 [ RunTime:0.000406s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1022035 [ RunTime:0.002544s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (150735,743278,361570,1012422,1025283,533073,166737,474734,551133,440666,412703,623713,843927,968891,226930,473391,472160,915629,466810,994870,345906,677590,157779,362902,389901,818047,594998,617701,781225,469609,1042653,274571,16504,261255,842286,344452,918443,604382,660962,707489,925897,240255,704503,342696,878578,617705,13515,1028340,710125,383366,606665,230286,112081,825707,1027036,363272,534010,577940,496987,327071) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1022035 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001317s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1022035 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003980s ]