SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 438017 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 438017 [ RunTime:0.002196s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (180949,841473,740210,410049,170553,672244,222673,756402,813417,999655,475697,374118,747393,307856,780979,590656,546751,371442,192705,695888,605642,496265,353489,913994,548334,685159,776525,527854,523845,699564,312871,154507,610834,695744,799896,336004,6974,582030,339494,1025524,818717,688465,973656,149937,906662,371058,963931,491608,556945,155008,156831,868776,126402,227631,444274,450513,917105,783490,999359,342455) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001045s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 438017 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000523s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 438017 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000504s ]