SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001236s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401373 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401373 [ RunTime:0.002358s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (20046,719416,386746,77398,1030705,815589,642578,628324,376505,173503,423068,894050,115678,417144,21460,129533,734745,609382,45737,971724,644220,774190,25166,853636,676361,918940,1018747,707668,341084,333156,243411,947802,937731,147833,978604,172200,448704,228002,128153,633647,470115,363647,439987,242018,935283,734160,151174,824009,392665,833004,902507,250860,796830,8787,377519,864999,45026,94995,966120,991121) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001084s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401373 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401373 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000418s ]