SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001321s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 221098 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 221098 [ RunTime:0.001771s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (375038,882511,19532,489267,743564,235222,462409,132923,645719,757974,197511,64059,424165,112114,673287,285422,867537,496172,730888,284858,1033318,943524,361695,698213,248198,705352,182431,778734,271362,373333,815176,279070,426530,928794,1014808,710484,581811,349072,936582,990612,127975,508347,755912,552994,513565,904091,110187,132048,849463,877889,298333,368908,320530,907301,200555,624878,450346,842197,851228,25086) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001109s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 221098 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 221098 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000428s ]