SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 382213 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 382213 [ RunTime:0.001966s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (224870,696577,753853,870902,209252,230555,894812,1011180,586992,822423,201812,570777,173499,314277,382927,528122,190435,493483,108228,632178,35247,101705,705800,213386,640479,174910,470951,503891,198691,920879,777252,490560,279176,337247,96008,900629,290634,1036978,673224,39350,600954,557523,140448,377865,320604,522829,871295,749966,945589,1014361,608087,190762,80950,375674,811423,718369,339775,880720,865060,19876) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001279s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 382213 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 382213 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000567s ]